Overview
Brought to you by YData
Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 5960 |
| Missing cells | 5271 |
| Missing cells (%) | 6.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.2 MiB |
| Average record size in memory | 211.6 B |
Variable types
| Categorical | 3 |
|---|---|
| Numeric | 10 |
MORTDUE is highly overall correlated with VALUE | High correlation |
VALUE is highly overall correlated with MORTDUE | High correlation |
MORTDUE has 518 (8.7%) missing values | Missing |
VALUE has 112 (1.9%) missing values | Missing |
REASON has 252 (4.2%) missing values | Missing |
JOB has 279 (4.7%) missing values | Missing |
YOJ has 515 (8.6%) missing values | Missing |
DEROG has 708 (11.9%) missing values | Missing |
DELINQ has 580 (9.7%) missing values | Missing |
CLAGE has 308 (5.2%) missing values | Missing |
NINQ has 510 (8.6%) missing values | Missing |
CLNO has 222 (3.7%) missing values | Missing |
DEBTINC has 1267 (21.3%) missing values | Missing |
YOJ has 415 (7.0%) zeros | Zeros |
DEROG has 4527 (76.0%) zeros | Zeros |
DELINQ has 4179 (70.1%) zeros | Zeros |
NINQ has 2531 (42.5%) zeros | Zeros |
CLNO has 62 (1.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-08 19:48:17.963885 |
|---|---|
| Analysis finished | 2025-04-08 19:48:21.979512 |
| Duration | 4.02 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5960 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5960 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5960 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4771 | |
| 1 | 1189 | 19.9% |
LOAN
Real number (ℝ)
| Distinct | 540 |
|---|---|
| Distinct (%) | 9.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18607.97 |
| Minimum | 1100 |
|---|---|
| Maximum | 89900 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 1100 |
|---|---|
| 5-th percentile | 5900 |
| Q1 | 11100 |
| median | 16300 |
| Q3 | 23300 |
| 95-th percentile | 40000 |
| Maximum | 89900 |
| Range | 88800 |
| Interquartile range (IQR) | 12200 |
Descriptive statistics
| Standard deviation | 11207.48 |
|---|---|
| Coefficient of variation (CV) | 0.60229464 |
| Kurtosis | 6.9325898 |
| Mean | 18607.97 |
| Median Absolute Deviation (MAD) | 6000 |
| Skewness | 2.0237807 |
| Sum | 1.109035 × 108 |
| Variance | 1.2560762 × 108 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 15000 | 105 | 1.8% |
| 10000 | 81 | 1.4% |
| 20000 | 74 | 1.2% |
| 25000 | 73 | 1.2% |
| 12000 | 69 | 1.2% |
| 17000 | 51 | 0.9% |
| 13000 | 50 | 0.8% |
| 5000 | 50 | 0.8% |
| 11000 | 47 | 0.8% |
| 8000 | 44 | 0.7% |
| Other values (530) | 5316 |
| Value | Count | Frequency (%) |
| 1100 | 1 | < 0.1% |
| 1300 | 1 | < 0.1% |
| 1500 | 2 | < 0.1% |
| 1700 | 2 | < 0.1% |
| 1800 | 2 | < 0.1% |
| 2000 | 6 | |
| 2100 | 1 | < 0.1% |
| 2200 | 3 | |
| 2300 | 3 | |
| 2400 | 6 |
| Value | Count | Frequency (%) |
| 89900 | 1 | |
| 89800 | 1 | |
| 89200 | 1 | |
| 89000 | 1 | |
| 88900 | 2 | |
| 88800 | 1 | |
| 88500 | 1 | |
| 88300 | 1 | |
| 87500 | 1 | |
| 87000 | 1 |
MORTDUE
Real number (ℝ)
High correlation Missing
| Distinct | 5053 |
|---|---|
| Distinct (%) | 92.9% |
| Missing | 518 |
| Missing (%) | 8.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 73760.817 |
| Minimum | 2063 |
|---|---|
| Maximum | 399550 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 2063 |
|---|---|
| 5-th percentile | 18232.4 |
| Q1 | 46276 |
| median | 65019 |
| Q3 | 91488 |
| 95-th percentile | 151999.55 |
| Maximum | 399550 |
| Range | 397487 |
| Interquartile range (IQR) | 45212 |
Descriptive statistics
| Standard deviation | 44457.609 |
|---|---|
| Coefficient of variation (CV) | 0.60272664 |
| Kurtosis | 6.4818663 |
| Mean | 73760.817 |
| Median Absolute Deviation (MAD) | 21655.5 |
| Skewness | 1.8144807 |
| Sum | 4.0140637 × 108 |
| Variance | 1.976479 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 42000 | 11 | 0.2% |
| 47000 | 10 | 0.2% |
| 65000 | 9 | 0.2% |
| 124000 | 7 | 0.1% |
| 45000 | 7 | 0.1% |
| 62000 | 7 | 0.1% |
| 70000 | 7 | 0.1% |
| 55000 | 7 | 0.1% |
| 50000 | 7 | 0.1% |
| 58000 | 6 | 0.1% |
| Other values (5043) | 5364 | |
| (Missing) | 518 | 8.7% |
| Value | Count | Frequency (%) |
| 2063 | 1 | |
| 2619 | 1 | |
| 2800 | 1 | |
| 3372 | 1 | |
| 4000 | 1 | |
| 4447 | 1 | |
| 4500 | 1 | |
| 4641 | 1 | |
| 4734 | 1 | |
| 4742 | 1 |
| Value | Count | Frequency (%) |
| 399550 | 1 | |
| 399412 | 1 | |
| 397299 | 1 | |
| 391000 | 1 | |
| 371003 | 1 | |
| 369874 | 1 | |
| 367917 | 1 | |
| 367089 | 1 | |
| 365528 | 1 | |
| 363737 | 1 |
VALUE
Real number (ℝ)
High correlation Missing
| Distinct | 5381 |
|---|---|
| Distinct (%) | 92.0% |
| Missing | 112 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101776.05 |
| Minimum | 8000 |
|---|---|
| Maximum | 855909 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 8000 |
|---|---|
| 5-th percentile | 39050.7 |
| Q1 | 66075.5 |
| median | 89235.5 |
| Q3 | 119824.25 |
| 95-th percentile | 203717.2 |
| Maximum | 855909 |
| Range | 847909 |
| Interquartile range (IQR) | 53748.75 |
Descriptive statistics
| Standard deviation | 57385.775 |
|---|---|
| Coefficient of variation (CV) | 0.56384362 |
| Kurtosis | 24.362805 |
| Mean | 101776.05 |
| Median Absolute Deviation (MAD) | 25764.5 |
| Skewness | 3.0533443 |
| Sum | 5.9518633 × 108 |
| Variance | 3.2931272 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 60000 | 15 | 0.3% |
| 80000 | 14 | 0.2% |
| 85000 | 12 | 0.2% |
| 65000 | 11 | 0.2% |
| 78000 | 10 | 0.2% |
| 72000 | 9 | 0.2% |
| 68000 | 8 | 0.1% |
| 87000 | 8 | 0.1% |
| 50000 | 8 | 0.1% |
| 125000 | 7 | 0.1% |
| Other values (5371) | 5746 | |
| (Missing) | 112 | 1.9% |
| Value | Count | Frequency (%) |
| 8000 | 1 | |
| 8800 | 1 | |
| 9100 | 1 | |
| 9500 | 1 | |
| 11550 | 1 | |
| 11702 | 1 | |
| 12414 | 1 | |
| 12500 | 1 | |
| 12737 | 1 | |
| 12972 | 1 |
| Value | Count | Frequency (%) |
| 855909 | 1 | |
| 854114 | 1 | |
| 854112 | 1 | |
| 850000 | 1 | |
| 512650 | 1 | |
| 511164 | 1 | |
| 505000 | 1 | |
| 471827 | 1 | |
| 469771 | 1 | |
| 469748 | 1 |
REASON
Categorical
Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 252 |
| Missing (%) | 4.2% |
| Memory size | 372.6 KiB |
| DebtCon | |
|---|---|
| HomeImp |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HomeImp |
|---|---|
| 2nd row | HomeImp |
| 3rd row | HomeImp |
| 4th row | HomeImp |
| 5th row | HomeImp |
Common Values
| Value | Count | Frequency (%) |
| DebtCon | 3928 | |
| HomeImp | 1780 | |
| (Missing) | 252 | 4.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| debtcon | 3928 | |
| homeimp | 1780 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 5708 | |
| o | 5708 | |
| D | 3928 | |
| b | 3928 | |
| t | 3928 | |
| C | 3928 | |
| n | 3928 | |
| m | 3560 | |
| H | 1780 | 4.5% |
| I | 1780 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 39956 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 5708 | |
| o | 5708 | |
| D | 3928 | |
| b | 3928 | |
| t | 3928 | |
| C | 3928 | |
| n | 3928 | |
| m | 3560 | |
| H | 1780 | 4.5% |
| I | 1780 | 4.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 39956 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 5708 | |
| o | 5708 | |
| D | 3928 | |
| b | 3928 | |
| t | 3928 | |
| C | 3928 | |
| n | 3928 | |
| m | 3560 | |
| H | 1780 | 4.5% |
| I | 1780 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 39956 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 5708 | |
| o | 5708 | |
| D | 3928 | |
| b | 3928 | |
| t | 3928 | |
| C | 3928 | |
| n | 3928 | |
| m | 3560 | |
| H | 1780 | 4.5% |
| I | 1780 | 4.5% |
JOB
Categorical
Missing
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 279 |
| Missing (%) | 4.7% |
| Memory size | 363.3 KiB |
| Other | |
|---|---|
| ProfExe | |
| Office | |
| Mgr | |
| Self | 193 |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.3120929 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Other |
|---|---|
| 2nd row | Other |
| 3rd row | Other |
| 4th row | Office |
| 5th row | Other |
Common Values
| Value | Count | Frequency (%) |
| Other | 2388 | |
| ProfExe | 1276 | |
| Office | 948 | 15.9% |
| Mgr | 767 | 12.9% |
| Self | 193 | 3.2% |
| Sales | 109 | 1.8% |
| (Missing) | 279 | 4.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| other | 2388 | |
| profexe | 1276 | |
| office | 948 | 16.7% |
| mgr | 767 | 13.5% |
| self | 193 | 3.4% |
| sales | 109 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4914 | |
| r | 4431 | |
| f | 3365 | |
| O | 3336 | |
| h | 2388 | |
| t | 2388 | |
| E | 1276 | 4.2% |
| x | 1276 | 4.2% |
| o | 1276 | 4.2% |
| P | 1276 | 4.2% |
| Other values (8) | 4252 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 30178 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 4914 | |
| r | 4431 | |
| f | 3365 | |
| O | 3336 | |
| h | 2388 | |
| t | 2388 | |
| E | 1276 | 4.2% |
| x | 1276 | 4.2% |
| o | 1276 | 4.2% |
| P | 1276 | 4.2% |
| Other values (8) | 4252 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 30178 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 4914 | |
| r | 4431 | |
| f | 3365 | |
| O | 3336 | |
| h | 2388 | |
| t | 2388 | |
| E | 1276 | 4.2% |
| x | 1276 | 4.2% |
| o | 1276 | 4.2% |
| P | 1276 | 4.2% |
| Other values (8) | 4252 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 30178 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 4914 | |
| r | 4431 | |
| f | 3365 | |
| O | 3336 | |
| h | 2388 | |
| t | 2388 | |
| E | 1276 | 4.2% |
| x | 1276 | 4.2% |
| o | 1276 | 4.2% |
| P | 1276 | 4.2% |
| Other values (8) | 4252 |
YOJ
Real number (ℝ)
Missing Zeros
| Distinct | 99 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 515 |
| Missing (%) | 8.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.9222681 |
| Minimum | 0 |
|---|---|
| Maximum | 41 |
| Zeros | 415 |
| Zeros (%) | 7.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 7 |
| Q3 | 13 |
| 95-th percentile | 24 |
| Maximum | 41 |
| Range | 41 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 7.5739822 |
|---|---|
| Coefficient of variation (CV) | 0.8488853 |
| Kurtosis | 0.37207248 |
| Mean | 8.9222681 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.98846007 |
| Sum | 48581.75 |
| Variance | 57.365207 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 415 | 7.0% |
| 1 | 363 | 6.1% |
| 2 | 347 | 5.8% |
| 5 | 333 | 5.6% |
| 4 | 324 | 5.4% |
| 6 | 318 | 5.3% |
| 3 | 307 | 5.2% |
| 9 | 286 | 4.8% |
| 10 | 285 | 4.8% |
| 8 | 256 | 4.3% |
| Other values (89) | 2211 | |
| (Missing) | 515 | 8.6% |
| Value | Count | Frequency (%) |
| 0 | 415 | |
| 0.1 | 14 | 0.2% |
| 0.2 | 10 | 0.2% |
| 0.25 | 1 | < 0.1% |
| 0.3 | 7 | 0.1% |
| 0.4 | 9 | 0.2% |
| 0.5 | 7 | 0.1% |
| 0.6 | 4 | 0.1% |
| 0.7 | 4 | 0.1% |
| 0.75 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 41 | 3 | 0.1% |
| 36 | 5 | 0.1% |
| 35 | 5 | 0.1% |
| 34 | 2 | < 0.1% |
| 33 | 2 | < 0.1% |
| 32 | 1 | < 0.1% |
| 31 | 12 | 0.2% |
| 30 | 30 | |
| 29.9 | 1 | < 0.1% |
| 29 | 29 |
DEROG
Real number (ℝ)
Missing Zeros
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 708 |
| Missing (%) | 11.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.25456969 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 4527 |
| Zeros (%) | 76.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.84604678 |
|---|---|
| Coefficient of variation (CV) | 3.3234388 |
| Kurtosis | 36.872763 |
| Mean | 0.25456969 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.3208703 |
| Sum | 1337 |
| Variance | 0.71579515 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 0 | 4527 | |
| 1 | 435 | 7.3% |
| 2 | 160 | 2.7% |
| 3 | 58 | 1.0% |
| 4 | 23 | 0.4% |
| 5 | 15 | 0.3% |
| 6 | 15 | 0.3% |
| 7 | 8 | 0.1% |
| 8 | 6 | 0.1% |
| 9 | 3 | 0.1% |
| (Missing) | 708 | 11.9% |
| Value | Count | Frequency (%) |
| 0 | 4527 | |
| 1 | 435 | 7.3% |
| 2 | 160 | 2.7% |
| 3 | 58 | 1.0% |
| 4 | 23 | 0.4% |
| 5 | 15 | 0.3% |
| 6 | 15 | 0.3% |
| 7 | 8 | 0.1% |
| 8 | 6 | 0.1% |
| 9 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 10 | 2 | < 0.1% |
| 9 | 3 | 0.1% |
| 8 | 6 | 0.1% |
| 7 | 8 | 0.1% |
| 6 | 15 | 0.3% |
| 5 | 15 | 0.3% |
| 4 | 23 | 0.4% |
| 3 | 58 | 1.0% |
| 2 | 160 | 2.7% |
| 1 | 435 |
DELINQ
Real number (ℝ)
Missing Zeros
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 580 |
| Missing (%) | 9.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.44944238 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 4179 |
| Zeros (%) | 70.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.1272659 |
|---|---|
| Coefficient of variation (CV) | 2.5081434 |
| Kurtosis | 23.565449 |
| Mean | 0.44944238 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.0231496 |
| Sum | 2418 |
| Variance | 1.2707284 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 0 | 4179 | |
| 1 | 654 | 11.0% |
| 2 | 250 | 4.2% |
| 3 | 129 | 2.2% |
| 4 | 78 | 1.3% |
| 5 | 38 | 0.6% |
| 6 | 27 | 0.5% |
| 7 | 13 | 0.2% |
| 8 | 5 | 0.1% |
| 10 | 2 | < 0.1% |
| Other values (4) | 5 | 0.1% |
| (Missing) | 580 | 9.7% |
| Value | Count | Frequency (%) |
| 0 | 4179 | |
| 1 | 654 | 11.0% |
| 2 | 250 | 4.2% |
| 3 | 129 | 2.2% |
| 4 | 78 | 1.3% |
| 5 | 38 | 0.6% |
| 6 | 27 | 0.5% |
| 7 | 13 | 0.2% |
| 8 | 5 | 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 15 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 11 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| 8 | 5 | 0.1% |
| 7 | 13 | 0.2% |
| 6 | 27 | 0.5% |
| 5 | 38 | |
| 4 | 78 |
CLAGE
Real number (ℝ)
Missing
| Distinct | 5314 |
|---|---|
| Distinct (%) | 94.0% |
| Missing | 308 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 179.76628 |
| Minimum | 0 |
|---|---|
| Maximum | 1168.2336 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 68.912654 |
| Q1 | 115.1167 |
| median | 173.46667 |
| Q3 | 231.56228 |
| 95-th percentile | 321.63333 |
| Maximum | 1168.2336 |
| Range | 1168.2336 |
| Interquartile range (IQR) | 116.44558 |
Descriptive statistics
| Standard deviation | 85.810092 |
|---|---|
| Coefficient of variation (CV) | 0.47734255 |
| Kurtosis | 7.5995493 |
| Mean | 179.76628 |
| Median Absolute Deviation (MAD) | 58.270411 |
| Skewness | 1.343412 |
| Sum | 1016039 |
| Variance | 7363.3718 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 102.5 | 7 | 0.1% |
| 206.9666667 | 7 | 0.1% |
| 177.5 | 6 | 0.1% |
| 123.7666667 | 6 | 0.1% |
| 95.36666667 | 6 | 0.1% |
| 109.5666667 | 6 | 0.1% |
| 304.3666667 | 5 | 0.1% |
| 97.4 | 5 | 0.1% |
| 118.6666667 | 5 | 0.1% |
| 232.3333333 | 5 | 0.1% |
| Other values (5304) | 5594 | |
| (Missing) | 308 | 5.2% |
| Value | Count | Frequency (%) |
| 0 | 2 | |
| 0.4867114508 | 1 | |
| 0.5071145295 | 1 | |
| 2.033333333 | 1 | |
| 2.820785578 | 1 | |
| 3.04438414 | 1 | |
| 4.412770061 | 1 | |
| 5.243341044 | 1 | |
| 6.133333333 | 1 | |
| 8.055265077 | 1 |
| Value | Count | Frequency (%) |
| 1168.233561 | 1 | |
| 1154.633333 | 1 | |
| 649.7471044 | 1 | |
| 648.3284926 | 1 | |
| 639.0581723 | 1 | |
| 638.2753611 | 1 | |
| 634.4618926 | 1 | |
| 632.1031857 | 1 | |
| 630.0333333 | 1 | |
| 629.0957663 | 1 |
NINQ
Real number (ℝ)
Missing Zeros
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 510 |
| Missing (%) | 8.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.186055 |
| Minimum | 0 |
|---|---|
| Maximum | 17 |
| Zeros | 2531 |
| Zeros (%) | 42.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 17 |
| Range | 17 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.728675 |
|---|---|
| Coefficient of variation (CV) | 1.4574998 |
| Kurtosis | 9.7865073 |
| Mean | 1.186055 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.6219842 |
| Sum | 6464 |
| Variance | 2.9883172 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 0 | 2531 | |
| 1 | 1339 | |
| 2 | 780 | 13.1% |
| 3 | 392 | 6.6% |
| 4 | 156 | 2.6% |
| 5 | 75 | 1.3% |
| 6 | 56 | 0.9% |
| 7 | 44 | 0.7% |
| 10 | 28 | 0.5% |
| 8 | 22 | 0.4% |
| Other values (6) | 27 | 0.5% |
| (Missing) | 510 | 8.6% |
| Value | Count | Frequency (%) |
| 0 | 2531 | |
| 1 | 1339 | |
| 2 | 780 | 13.1% |
| 3 | 392 | 6.6% |
| 4 | 156 | 2.6% |
| 5 | 75 | 1.3% |
| 6 | 56 | 0.9% |
| 7 | 44 | 0.7% |
| 8 | 22 | 0.4% |
| 9 | 11 | 0.2% |
| Value | Count | Frequency (%) |
| 17 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 2 | < 0.1% |
| 12 | 2 | < 0.1% |
| 11 | 10 | 0.2% |
| 10 | 28 | |
| 9 | 11 | 0.2% |
| 8 | 22 | 0.4% |
| 7 | 44 | |
| 6 | 56 |
CLNO
Real number (ℝ)
Missing Zeros
| Distinct | 62 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 222 |
| Missing (%) | 3.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.296096 |
| Minimum | 0 |
|---|---|
| Maximum | 71 |
| Zeros | 62 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 15 |
| median | 20 |
| Q3 | 26 |
| 95-th percentile | 40 |
| Maximum | 71 |
| Range | 71 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 10.138933 |
|---|---|
| Coefficient of variation (CV) | 0.47609351 |
| Kurtosis | 1.1576727 |
| Mean | 21.296096 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.77505176 |
| Sum | 122197 |
| Variance | 102.79797 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 16 | 316 | 5.3% |
| 19 | 307 | 5.2% |
| 24 | 264 | 4.4% |
| 23 | 259 | 4.3% |
| 21 | 235 | 3.9% |
| 20 | 231 | 3.9% |
| 18 | 225 | 3.8% |
| 25 | 221 | 3.7% |
| 15 | 217 | 3.6% |
| 22 | 212 | 3.6% |
| Other values (52) | 3251 | |
| (Missing) | 222 | 3.7% |
| Value | Count | Frequency (%) |
| 0 | 62 | |
| 1 | 6 | 0.1% |
| 2 | 15 | 0.3% |
| 3 | 34 | 0.6% |
| 4 | 42 | 0.7% |
| 5 | 47 | 0.8% |
| 6 | 60 | |
| 7 | 76 | |
| 8 | 92 | |
| 9 | 127 |
| Value | Count | Frequency (%) |
| 71 | 2 | < 0.1% |
| 65 | 3 | 0.1% |
| 64 | 5 | 0.1% |
| 63 | 1 | < 0.1% |
| 58 | 3 | 0.1% |
| 57 | 1 | < 0.1% |
| 56 | 6 | |
| 55 | 14 | |
| 53 | 2 | < 0.1% |
| 52 | 5 | 0.1% |
DEBTINC
Real number (ℝ)
Missing
| Distinct | 4693 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1267 |
| Missing (%) | 21.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.779915 |
| Minimum | 0.52449922 |
|---|---|
| Maximum | 203.31215 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 46.7 KiB |
Quantile statistics
| Minimum | 0.52449922 |
|---|---|
| 5-th percentile | 20.511886 |
| Q1 | 29.140031 |
| median | 34.818262 |
| Q3 | 39.003141 |
| 95-th percentile | 42.767852 |
| Maximum | 203.31215 |
| Range | 202.78765 |
| Interquartile range (IQR) | 9.8631093 |
Descriptive statistics
| Standard deviation | 8.6017462 |
|---|---|
| Coefficient of variation (CV) | 0.25464084 |
| Kurtosis | 50.504042 |
| Mean | 33.779915 |
| Median Absolute Deviation (MAD) | 4.8149283 |
| Skewness | 2.8523534 |
| Sum | 158529.14 |
| Variance | 73.990037 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 34.96414103 | 1 | < 0.1% |
| 41.57670052 | 1 | < 0.1% |
| 41.39546183 | 1 | < 0.1% |
| 20.68871482 | 1 | < 0.1% |
| 35.98208365 | 1 | < 0.1% |
| 37.82721876 | 1 | < 0.1% |
| 34.88554143 | 1 | < 0.1% |
| 41.82491442 | 1 | < 0.1% |
| 37.82317309 | 1 | < 0.1% |
| 42.17658506 | 1 | < 0.1% |
| Other values (4683) | 4683 | |
| (Missing) | 1267 | 21.3% |
| Value | Count | Frequency (%) |
| 0.5244992154 | 1 | |
| 0.7202950067 | 1 | |
| 0.8381175254 | 1 | |
| 1.028930968 | 1 | |
| 1.565931047 | 1 | |
| 1.603507978 | 1 | |
| 1.85553998 | 1 | |
| 1.909225163 | 1 | |
| 1.920694367 | 1 | |
| 2.365195413 | 1 |
| Value | Count | Frequency (%) |
| 203.3121487 | 1 | |
| 144.1890013 | 1 | |
| 143.949605 | 1 | |
| 133.5282704 | 1 | |
| 114.0505277 | 1 | |
| 91.61259998 | 1 | |
| 84.61388869 | 1 | |
| 84.37903408 | 1 | |
| 78.65438605 | 1 | |
| 76.42147805 | 1 |
Interactions
Correlations
| BAD | CLAGE | CLNO | DEBTINC | DELINQ | DEROG | JOB | LOAN | MORTDUE | NINQ | REASON | VALUE | YOJ | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BAD | 1.000 | 0.164 | 0.139 | 0.296 | 0.324 | 0.253 | 0.116 | 0.121 | 0.091 | 0.182 | 0.035 | 0.096 | 0.089 |
| CLAGE | 0.164 | 1.000 | 0.242 | 0.008 | -0.000 | -0.085 | 0.105 | 0.123 | 0.131 | -0.098 | 0.126 | 0.193 | 0.173 |
| CLNO | 0.139 | 0.242 | 1.000 | 0.192 | 0.148 | 0.041 | 0.151 | 0.143 | 0.346 | 0.149 | 0.201 | 0.364 | 0.045 |
| DEBTINC | 0.296 | 0.008 | 0.192 | 1.000 | 0.046 | 0.014 | 0.092 | 0.120 | 0.180 | 0.205 | 0.052 | 0.166 | -0.065 |
| DELINQ | 0.324 | -0.000 | 0.148 | 0.046 | 1.000 | 0.241 | 0.050 | -0.061 | -0.027 | 0.077 | 0.040 | -0.036 | 0.029 |
| DEROG | 0.253 | -0.085 | 0.041 | 0.014 | 0.241 | 1.000 | 0.036 | 0.007 | -0.039 | 0.172 | 0.000 | -0.054 | -0.067 |
| JOB | 0.116 | 0.105 | 0.151 | 0.092 | 0.050 | 0.036 | 1.000 | 0.137 | 0.174 | 0.072 | 0.146 | 0.184 | 0.080 |
| LOAN | 0.121 | 0.123 | 0.143 | 0.120 | -0.061 | 0.007 | 0.137 | 1.000 | 0.199 | 0.043 | 0.305 | 0.346 | 0.092 |
| MORTDUE | 0.091 | 0.131 | 0.346 | 0.180 | -0.027 | -0.039 | 0.174 | 0.199 | 1.000 | 0.056 | 0.116 | 0.861 | -0.058 |
| NINQ | 0.182 | -0.098 | 0.149 | 0.205 | 0.077 | 0.172 | 0.072 | 0.043 | 0.056 | 1.000 | 0.147 | 0.013 | -0.061 |
| REASON | 0.035 | 0.126 | 0.201 | 0.052 | 0.040 | 0.000 | 0.146 | 0.305 | 0.116 | 0.147 | 1.000 | 0.066 | 0.103 |
| VALUE | 0.096 | 0.193 | 0.364 | 0.166 | -0.036 | -0.054 | 0.184 | 0.346 | 0.861 | 0.013 | 0.066 | 1.000 | 0.032 |
| YOJ | 0.089 | 0.173 | 0.045 | -0.065 | 0.029 | -0.067 | 0.080 | 0.092 | -0.058 | -0.061 | 0.103 | 0.032 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| BAD | LOAN | MORTDUE | VALUE | REASON | JOB | YOJ | DEROG | DELINQ | CLAGE | NINQ | CLNO | DEBTINC | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1100 | 25860.0 | 39025.0 | HomeImp | Other | 10.5 | 0.0 | 0.0 | 94.366667 | 1.0 | 9.0 | NaN |
| 1 | 1 | 1300 | 70053.0 | 68400.0 | HomeImp | Other | 7.0 | 0.0 | 2.0 | 121.833333 | 0.0 | 14.0 | NaN |
| 2 | 1 | 1500 | 13500.0 | 16700.0 | HomeImp | Other | 4.0 | 0.0 | 0.0 | 149.466667 | 1.0 | 10.0 | NaN |
| 3 | 1 | 1500 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | 0 | 1700 | 97800.0 | 112000.0 | HomeImp | Office | 3.0 | 0.0 | 0.0 | 93.333333 | 0.0 | 14.0 | NaN |
| 5 | 1 | 1700 | 30548.0 | 40320.0 | HomeImp | Other | 9.0 | 0.0 | 0.0 | 101.466002 | 1.0 | 8.0 | 37.113614 |
| 6 | 1 | 1800 | 48649.0 | 57037.0 | HomeImp | Other | 5.0 | 3.0 | 2.0 | 77.100000 | 1.0 | 17.0 | NaN |
| 7 | 1 | 1800 | 28502.0 | 43034.0 | HomeImp | Other | 11.0 | 0.0 | 0.0 | 88.766030 | 0.0 | 8.0 | 36.884894 |
| 8 | 1 | 2000 | 32700.0 | 46740.0 | HomeImp | Other | 3.0 | 0.0 | 2.0 | 216.933333 | 1.0 | 12.0 | NaN |
| 9 | 1 | 2000 | NaN | 62250.0 | HomeImp | Sales | 16.0 | 0.0 | 0.0 | 115.800000 | 0.0 | 13.0 | NaN |
| BAD | LOAN | MORTDUE | VALUE | REASON | JOB | YOJ | DEROG | DELINQ | CLAGE | NINQ | CLNO | DEBTINC | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5950 | 0 | 87500 | 55938.0 | 86794.0 | DebtCon | Other | 15.0 | 0.0 | 0.0 | 223.881040 | 0.0 | 16.0 | 36.753653 |
| 5951 | 0 | 88300 | 54004.0 | 94838.0 | DebtCon | Other | 16.0 | 0.0 | 0.0 | 193.702051 | 0.0 | 15.0 | 36.262691 |
| 5952 | 0 | 88500 | 50240.0 | 94687.0 | DebtCon | Other | 16.0 | 0.0 | 0.0 | 214.426206 | 0.0 | 16.0 | 34.751158 |
| 5953 | 0 | 88800 | 53307.0 | 94058.0 | DebtCon | Other | 16.0 | 0.0 | 0.0 | 218.304978 | 0.0 | 15.0 | 34.242465 |
| 5954 | 0 | 88900 | 48919.0 | 93371.0 | DebtCon | Other | 15.0 | 0.0 | 1.0 | 205.650159 | 0.0 | 15.0 | 34.818262 |
| 5955 | 0 | 88900 | 57264.0 | 90185.0 | DebtCon | Other | 16.0 | 0.0 | 0.0 | 221.808718 | 0.0 | 16.0 | 36.112347 |
| 5956 | 0 | 89000 | 54576.0 | 92937.0 | DebtCon | Other | 16.0 | 0.0 | 0.0 | 208.692070 | 0.0 | 15.0 | 35.859971 |
| 5957 | 0 | 89200 | 54045.0 | 92924.0 | DebtCon | Other | 15.0 | 0.0 | 0.0 | 212.279697 | 0.0 | 15.0 | 35.556590 |
| 5958 | 0 | 89800 | 50370.0 | 91861.0 | DebtCon | Other | 14.0 | 0.0 | 0.0 | 213.892709 | 0.0 | 16.0 | 34.340882 |
| 5959 | 0 | 89900 | 48811.0 | 88934.0 | DebtCon | Other | 15.0 | 0.0 | 0.0 | 219.601002 | 0.0 | 16.0 | 34.571519 |